123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411 |
- <?xml version="1.0" encoding="UTF-8"?>
- <DocRoot>
- <Parameters/>
- <DataSources>
- <Reference name="query" alias.zh_CN="结算单" alias.en="" alias.zh_TW="結算單" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1" info="FMSettleBill.bos-query"/>
- <Reference name="SettlementBillTDQuery" info="::/com/kingdee/eas/fm/fs/SettlementBillTDQuery.bos-query"/>
- </DataSources>
- <Styles version="1.0">
- <Style id="3">
- <Alignment horizontal="right"/>
- </Style>
- <Style id="5">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
- </Borders>
- </Style>
- <Style id="7">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
- </Borders>
- </Style>
- <Style id="2">
- <Alignment horizontal="left"/>
- </Style>
- <Style id="0"/>
- <Style id="4">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
- </Borders>
- <Alignment wrapText="true"/>
- </Style>
- <Style id="8">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
- </Borders>
- <Alignment horizontal="left"/>
- </Style>
- <Style id="6">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
- </Borders>
- <Alignment horizontal="center" vertical="middle"/>
- </Style>
- <Style id="1">
- <Font size="14" bold="true" italic="false"/>
- </Style>
- </Styles>
- <Report type="r1-print" version="6.2.0">
- <Page id="page1" width="1720" height="2470">
- <Sub-objects>
- <PrintLayoutGrid id="layoutGrid1" styleId="0" x="0" y="0" horizontalFill="true">
- <Data/>
- <Col width="164" id="column1" styleId="0"/>
- <Col width="78" id="column2" styleId="0"/>
- <Col width="178" id="column3" styleId="0"/>
- <Col width="252" id="column4" styleId="0"/>
- <Col width="198" id="column9"/>
- <Col width="109" id="column5" styleId="0"/>
- <Col width="71" id="column6" styleId="0"/>
- <Col width="195" id="column7" styleId="0"/>
- <Col width="249" id="column8" styleId="0"/>
- <Col width="226" id="column10"/>
- <TR height="100" id="row1" styleId="0">
- <TD id="cell1" styleId="1">
- <Script><![CDATA[setValue(getValue() + "结算单");]]></Script>
- <Value type="field" dataSource="query">bizType</Value>
- </TD>
- <TD id="cell2" styleId="0"/>
- <TD id="cell3" styleId="0"/>
- <TD id="cell40" styleId="0"/>
- <TD id="cell105"/>
- <TD id="cell53" styleId="0"/>
- <TD id="cell66" styleId="0"/>
- <TD id="cell79" styleId="0"/>
- <TD id="cell92" styleId="0"/>
- <TD id="cell118"/>
- </TR>
- <TR height="100" id="row2" styleId="0">
- <TD id="cell4" styleId="0">
- <Value type="text"><![CDATA[申請單位:]]></Value>
- </TD>
- <TD id="cell5" styleId="2">
- <Value type="field" dataSource="query">applyUnit</Value>
- </TD>
- <TD id="cell6" styleId="0"/>
- <TD id="cell41" styleId="3">
- <Value type="text"><![CDATA[單據日期:]]></Value>
- </TD>
- <TD id="cell106">
- <Value type="field" dataSource="query">createTime</Value>
- </TD>
- <TD id="cell54" styleId="2"/>
- <TD id="cell67" styleId="0"/>
- <TD id="cell80" styleId="3">
- <Value type="text"><![CDATA[單據編號:]]></Value>
- </TD>
- <TD id="cell93" styleId="0">
- <Value type="field" dataSource="query">number</Value>
- </TD>
- <TD id="cell119"/>
- </TR>
- <TR height="100" id="row3" styleId="0">
- <TD id="cell7" styleId="0">
- <Value type="text"><![CDATA[源單據:]]></Value>
- </TD>
- <TD id="cell8" styleId="0">
- <Value type="field" dataSource="query">souceBillNumber</Value>
- </TD>
- <TD id="cell9" styleId="0"/>
- <TD id="cell42" styleId="0"/>
- <TD id="cell107"/>
- <TD id="cell55" styleId="0">
- <Value type="text"><![CDATA[憑證號:]]></Value>
- </TD>
- <TD id="cell68" styleId="0"/>
- <TD id="cell81" styleId="2">
- <Value type="field" dataSource="query">voucherNumber</Value>
- </TD>
- <TD id="cell94" styleId="0"/>
- <TD id="cell120"/>
- </TR>
- <TR height="100" id="row4" styleId="0">
- <TD id="cell10" styleId="4">
- <Value type="text"><![CDATA[收 款 方]]></Value>
- </TD>
- <TD id="cell11" styleId="5">
- <Value type="field" dataSource="query">payeeFullName</Value>
- </TD>
- <TD id="cell12" styleId="0"/>
- <TD id="cell43" styleId="0"/>
- <TD id="cell108"/>
- <TD id="cell56" styleId="4">
- <Value type="text"><![CDATA[付 款 方]]></Value>
- </TD>
- <TD id="cell69" styleId="5">
- <Value type="field" dataSource="query">payerFullName</Value>
- </TD>
- <TD id="cell82" styleId="0"/>
- <TD id="cell95" styleId="0"/>
- <TD id="cell121"/>
- </TR>
- <TR height="100" id="row5" styleId="0">
- <TD id="cell13" styleId="0"/>
- <TD id="cell14" styleId="4">
- <Value type="text"><![CDATA[銀 行 賬 戶]]></Value>
- </TD>
- <TD id="cell15" styleId="5">
- <Value type="text"><![CDATA[帳號]]></Value>
- </TD>
- <TD id="cell44" styleId="5">
- <Value type="field" dataSource="query">payeeBankAccountNumber</Value>
- </TD>
- <TD id="cell109"/>
- <TD id="cell57" styleId="0"/>
- <TD id="cell70" styleId="4">
- <Value type="text"><![CDATA[銀 行 賬 戶]]></Value>
- </TD>
- <TD id="cell83" styleId="5">
- <Value type="text"><![CDATA[帳號]]></Value>
- </TD>
- <TD id="cell96" styleId="5">
- <Value type="field" dataSource="query">payerBankAccountNumber</Value>
- </TD>
- <TD id="cell122"/>
- </TR>
- <TR height="100" id="row6" styleId="0">
- <TD id="cell16" styleId="0"/>
- <TD id="cell17" styleId="0"/>
- <TD id="cell18" styleId="5">
- <Value type="text"><![CDATA[開戶行]]></Value>
- </TD>
- <TD id="cell45" styleId="5">
- <Value type="field" dataSource="query">payeeBankAccountBank</Value>
- </TD>
- <TD id="cell110"/>
- <TD id="cell58" styleId="0"/>
- <TD id="cell71" styleId="0"/>
- <TD id="cell84" styleId="5">
- <Value type="text"><![CDATA[開戶行]]></Value>
- </TD>
- <TD id="cell97" styleId="5">
- <Value type="field" dataSource="query">payerBankAccountBank</Value>
- </TD>
- <TD id="cell123"/>
- </TR>
- <TR height="100" id="row7" styleId="0">
- <TD id="cell19" styleId="0"/>
- <TD id="cell20" styleId="4">
- <Value type="text"><![CDATA[內 部 賬 戶]]></Value>
- </TD>
- <TD id="cell21" styleId="5">
- <Value type="text"><![CDATA[名稱]]></Value>
- </TD>
- <TD id="cell46" styleId="5">
- <Value type="field" dataSource="query">payeeInnerAcctName</Value>
- </TD>
- <TD id="cell111"/>
- <TD id="cell59" styleId="0"/>
- <TD id="cell72" styleId="4">
- <Value type="text"><![CDATA[內 部 賬 戶]]></Value>
- </TD>
- <TD id="cell85" styleId="5">
- <Value type="text"><![CDATA[名稱]]></Value>
- </TD>
- <TD id="cell98" styleId="5">
- <Value type="field" dataSource="query">payerInnerAcctName</Value>
- </TD>
- <TD id="cell124"/>
- </TR>
- <TR height="100" id="row8" styleId="0">
- <TD id="cell22" styleId="0"/>
- <TD id="cell23" styleId="0"/>
- <TD id="cell24" styleId="5">
- <Value type="text"><![CDATA[帳號]]></Value>
- </TD>
- <TD id="cell47" styleId="5">
- <Value type="field" dataSource="query">payeeInnerAcct.acctNumber</Value>
- </TD>
- <TD id="cell112"/>
- <TD id="cell60" styleId="0"/>
- <TD id="cell73" styleId="0"/>
- <TD id="cell86" styleId="5">
- <Value type="text"><![CDATA[帳號]]></Value>
- </TD>
- <TD id="cell99" styleId="5">
- <Value type="field" dataSource="query">payerInnerAcct.acctNumber</Value>
- </TD>
- <TD id="cell125"/>
- </TR>
- <TR height="100" id="row9" styleId="0">
- <TD id="cell25" styleId="0"/>
- <TD id="cell26" styleId="5">
- <Value type="text"><![CDATA[幣別]]></Value>
- </TD>
- <TD id="cell27" styleId="0"/>
- <TD id="cell48" styleId="5">
- <Value type="field" dataSource="query">currency.name</Value>
- </TD>
- <TD id="cell113"/>
- <TD id="cell61" styleId="5">
- <Value type="text"><![CDATA[金額]]></Value>
- </TD>
- <TD id="cell74" styleId="5"/>
- <TD id="cell87" styleId="0"/>
- <TD id="cell100" styleId="5">
- <Value type="field" dataSource="query">amount</Value>
- </TD>
- <TD id="cell126"/>
- </TR>
- <TR height="100" id="row10" styleId="0">
- <TD id="cell28" styleId="0"/>
- <TD id="cell29" styleId="5">
- <Value type="text"><![CDATA[匯率]]></Value>
- </TD>
- <TD id="cell30" styleId="0"/>
- <TD id="cell49" styleId="6">
- <Value type="field" dataSource="query">exchange</Value>
- </TD>
- <TD id="cell114"/>
- <TD id="cell62" styleId="7">
- <Value type="text"><![CDATA[折本位幣]]></Value>
- </TD>
- <TD id="cell75" styleId="5"/>
- <TD id="cell88" styleId="0"/>
- <TD id="cell101" styleId="5">
- <Value type="field" dataSource="query">localAmount</Value>
- </TD>
- <TD id="cell127"/>
- </TR>
- <TR height="100" id="row11" styleId="0">
- <TD id="cell31" styleId="4">
- <Value type="text"><![CDATA[交 易 描 述]]></Value>
- </TD>
- <TD id="cell32" styleId="8">
- <Value type="field" dataSource="query">description</Value>
- </TD>
- <TD id="cell33" styleId="0"/>
- <TD id="cell50" styleId="0"/>
- <TD id="cell115"/>
- <TD id="cell63" styleId="0"/>
- <TD id="cell76" styleId="0"/>
- <TD id="cell89" styleId="5">
- <Value type="text"><![CDATA[票據類型]]></Value>
- </TD>
- <TD id="cell102" styleId="5">
- <Value type="field" dataSource="query">settleTypeName</Value>
- </TD>
- <TD id="cell128"/>
- </TR>
- <TR height="100" id="row12" styleId="0">
- <TD id="cell34" styleId="0"/>
- <TD id="cell35" styleId="0"/>
- <TD id="cell36" styleId="0"/>
- <TD id="cell51" styleId="0"/>
- <TD id="cell116"/>
- <TD id="cell64" styleId="0"/>
- <TD id="cell77" styleId="0"/>
- <TD id="cell90" styleId="5">
- <Value type="text"><![CDATA[票據號]]></Value>
- </TD>
- <TD id="cell103" styleId="5">
- <Value type="field" dataSource="query">outerSettleNumber</Value>
- </TD>
- <TD id="cell129"/>
- </TR>
- <TR height="100" id="row13" styleId="0">
- <TD id="cell37" styleId="0">
- <Value type="text"><![CDATA[制單:]]></Value>
- </TD>
- <TD id="cell38" styleId="0">
- <Value type="field" dataSource="query">creatorName</Value>
- </TD>
- <TD id="cell52" styleId="3">
- <Value type="text"><![CDATA[受理:]]></Value>
- </TD>
- <TD id="cell117" styleId="2">
- <Value type="field" dataSource="query">acceptorName</Value>
- </TD>
- <TD id="cell143" styleId="3">
- <Value type="text"><![CDATA[審核:]]></Value>
- </TD>
- <TD id="cell156" styleId="2">
- <Value type="field" dataSource="SettlementBillTDQuery">auditor.name</Value>
- </TD>
- <TD id="cell65" styleId="3">
- <Value type="text"><![CDATA[出納:]]></Value>
- </TD>
- <TD id="cell91" styleId="0">
- <Value type="field" dataSource="query">casherName</Value>
- </TD>
- <TD id="cell104" styleId="3">
- <Value type="text"><![CDATA[會計:]]></Value>
- </TD>
- <TD id="cell130">
- <Value type="field" dataSource="query">accountName</Value>
- </TD>
- </TR>
- <MergeBlocks>
- <Block left="0" right="9" top="0" bottom="0"/>
- <Block left="1" right="2" top="1" bottom="1"/>
- <Block left="5" right="6" top="1" bottom="1"/>
- <Block left="8" right="9" top="1" bottom="1"/>
- <Block left="1" right="2" top="2" bottom="2"/>
- <Block left="5" right="6" top="2" bottom="2"/>
- <Block left="7" right="9" top="2" bottom="2"/>
- <Block left="0" right="0" top="3" bottom="9"/>
- <Block left="1" right="4" top="3" bottom="3"/>
- <Block left="5" right="5" top="3" bottom="7"/>
- <Block left="6" right="9" top="3" bottom="3"/>
- <Block left="1" right="1" top="4" bottom="5"/>
- <Block left="3" right="4" top="4" bottom="4"/>
- <Block left="6" right="6" top="4" bottom="5"/>
- <Block left="8" right="9" top="4" bottom="4"/>
- <Block left="3" right="4" top="5" bottom="5"/>
- <Block left="8" right="9" top="5" bottom="5"/>
- <Block left="1" right="1" top="6" bottom="7"/>
- <Block left="3" right="4" top="6" bottom="6"/>
- <Block left="6" right="6" top="6" bottom="7"/>
- <Block left="8" right="9" top="6" bottom="6"/>
- <Block left="3" right="4" top="7" bottom="7"/>
- <Block left="8" right="9" top="7" bottom="7"/>
- <Block left="1" right="2" top="8" bottom="8"/>
- <Block left="3" right="4" top="8" bottom="8"/>
- <Block left="5" right="7" top="8" bottom="8"/>
- <Block left="8" right="9" top="8" bottom="8"/>
- <Block left="1" right="2" top="9" bottom="9"/>
- <Block left="3" right="4" top="9" bottom="9"/>
- <Block left="5" right="7" top="9" bottom="9"/>
- <Block left="8" right="9" top="9" bottom="9"/>
- <Block left="0" right="0" top="10" bottom="11"/>
- <Block left="1" right="6" top="10" bottom="11"/>
- <Block left="8" right="9" top="10" bottom="10"/>
- <Block left="8" right="9" top="11" bottom="11"/>
- <Block left="1" right="2" top="12" bottom="12"/>
- <Block left="5" right="6" top="12" bottom="12"/>
- </MergeBlocks>
- </PrintLayoutGrid>
- </Sub-objects>
- </Page>
- </Report>
- <PrintInfo>
- <PaperSetup>
- <Paper>iso-a4</Paper>
- <Orientation>PORTRAIT</Orientation>
- <PageMargin left="190" right="190" top="250" bottom="250"/>
- <Header height="150" margin="100"/>
- <Footer height="150" margin="100"/>
- </PaperSetup>
- <PrinterSetup>
- <DynamicPaper>false</DynamicPaper>
- <EconomizePaper>false</EconomizePaper>
- </PrinterSetup>
- <PreviewSetup>
- <BackgroundPicture>false</BackgroundPicture>
- </PreviewSetup>
- </PrintInfo>
- </DocRoot>
|